CREATE PROCEDURE dbo.[GetAfiliadosNoJefes_Activos]
AS
BEGIN
select * from Persona
where Persona.Activo = 1 and Persona.Afiliado = 1 and Persona.Fallecido = 0
and Persona.ID not in (Select g.Jefe from GrupoFamiliar g)
END
GO
